{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "import pandas as pd\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "ll = \"D:\\Test\\A21_1110\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(ll, 'r', encoding='utf-8') as f:\n",
    "    file = f.read()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "file = file.replace('\\n', '')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"[][{'item_id': 556905499087, 'title': 'A21男装男士外套冬季新款轻薄羽绒服男轻便薄款外套男短款', 'img': '//img.alicdn.com/bao/uploaded/i4/1601145275/O1CN011opzig2Ew2jazCi_!!0-item_pic.jpg', 'sold': '838', 'quantity': 0, 'totalSoldQuantity': 30913, 'url': '//detail.m.tmall.com/item.htm?id=556905499087', 'price': '679.00', 'titleUnderIconList': [{'type': 'img', 'value': {'url': '//img.alicdn.com/tfs/TB1PSExc9zqK1RjSZFjXXblCFXa-150-36.png?getAvatar=avatar', 'width': '36', 'height': '150'}}], 'store_name': 'a21fs', 'page': '1'}, {'item_id': 574998833929, 'title': 'A21男装秋季纯色毛衣男宽松圆领针织衫男长袖套头衫男生青年线衣', 'img': '//img.alicdn.com/bao/uploaded/i1/1601145275/O1CN011opzie5wsMPpZHo_!!0-item_pic.jpg', 'sold': '788', 'quantity': 0, 'totalSoldQuantity': 2052, 'url': '//detail.m.tmall.com/item.htm?id=574998833929', 'price': '389.00', 'titleUnderIconList': [{'type': 'img', 'value': {'url': '//img.alicdn.com/tfs/TB1PSExc9zqK1RjSZFjXXblCFXa-150-36.png?getAvatar=avatar', 'width': '36', 'height': '150'}}], 'store_name': 'a21fs', 'page': '1'}, {'item_id': 573079737250, 'title': 'A21秋季男装2018新款连帽卫衣男潮假两件套头潮流嘻哈男生外套秋', 'img': '//img.alicdn.com/bao/uploaded/i1/1601145275/O1CN01VWk7Ie1opzieIl17C_!!0-item_pic.jpg', 'sold': '1056', 'quantity': 0, 'totalSoldQuantity': 5969, 'url': '//detail.m.tmall.com/item.htm?id=573079737250', 'price': '269.00', 'titleUnderIconList': [{'type': 'img', 'value': {'url': '//img.alicdn.com/tfs/TB1PSExc9zqK1RjSZFjXXblCFXa-150-36.png?getAvatar=avatar', 'width': '36', 'height': '150'}}], 'store_name': 'a21fs', 'page': '1'}, {'item_id': 555337765523, 'title': 'A21秋季男士牛仔裤男潮弹力小脚裤修身潮流牛仔裤子学生休闲长裤', 'img': '//img.alicdn.com/bao/uploaded/i4/1601145275/O1CN011opzicDVtPKMtjp_!!0-item_pic.jpg', 'sold': '3282', 'quantity': 0, 'totalSoldQuantity': 58030, 'url': '//detail.m.tmall.com/item.htm?id=555337765523', 'price': '289.00', 'titleUnderIconList': [{'type': 'img', 'value': {'url': '//img.alicdn.com/tfs/TB1PSExc9zqK1RjSZFjXXblCFXa-150-36.png?getAvatar=avatar', 'width': '36', 'height': '150'}}], 'store_name': 'a2\""
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "file1 = file[:2000]\n",
    "file1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "base_dir = r'D:\\Test\\tmall'\n",
    "lst_brand = [base_dir + '\\\\' + i for i in os.listdir(base_dir)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "# new_file = test.sub(\"'store_name'\", file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "# new_file = test.sub(\"'store_name'\", file)\n",
    "# last_file = new_file.split(']')[1:-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "D:\\Test\\tmall\\7modifier_1110\n",
      "D:\\Test\\tmall\\A21_1110\n",
      "D:\\Test\\tmall\\Aape_1110\n",
      "D:\\Test\\tmall\\Adidas_1110\n",
      "D:\\Test\\tmall\\BASIC HOUSE_1110\n",
      "D:\\Test\\tmall\\Canada goose_1110\n",
      "D:\\Test\\tmall\\clot_1110\n",
      "D:\\Test\\tmall\\FILA_1110\n",
      "D:\\Test\\tmall\\GU_1110\n",
      "D:\\Test\\tmall\\GXG_1110\n",
      "D:\\Test\\tmall\\JACKJONES_1110\n"
     ]
    },
    {
     "ename": "SyntaxError",
     "evalue": "EOL while scanning string literal (<string>, line 1)",
     "output_type": "error",
     "traceback": [
      "Traceback \u001b[1;36m(most recent call last)\u001b[0m:\n",
      "  File \u001b[0;32m\"C:\\ProgramData\\Anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py\"\u001b[0m, line \u001b[0;32m2961\u001b[0m, in \u001b[0;35mrun_code\u001b[0m\n    exec(code_obj, self.user_global_ns, self.user_ns)\n",
      "\u001b[1;36m  File \u001b[1;32m\"<ipython-input-53-2c06a6203107>\"\u001b[1;36m, line \u001b[1;32m11\u001b[1;36m, in \u001b[1;35m<module>\u001b[1;36m\u001b[0m\n\u001b[1;33m    pages = eval(one_page + ']')\u001b[0m\n",
      "\u001b[1;36m  File \u001b[1;32m\"<string>\"\u001b[1;36m, line \u001b[1;32m1\u001b[0m\n\u001b[1;33m    [{'item_id': 554896649712, 'title': 'JackJones杰克琼斯秋冬男女情侣圆领修身薄款含羊毛针织衫毛衣', 'img': '//img.alicdn.com/bao/uploaded/i4/305358018/O1CN01296I86Frg4w6bMe-305358018.jpg', 'sold': '364', 'quantity': 0, 'totalSoldQuantity': 28494, 'url': '//detail.m.tmall.com/item.htm?id=554896649712', 'price': '299.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 556970556195, 'title': 'JackJones杰克琼斯男女装秋潮纯色含羊毛情侣套头圆领针织衫毛衣', 'img': '//img.alicdn.com/bao/uploaded/i1/305358018/O1CN014hTsJH296I89Nbhwy_!!0-item_pic.jpg', 'sold': '29', 'quantity': 0, 'totalSoldQuantity': 13558, 'url': '//detail.m.tmall.com/item.htm?id=556970556195', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 551481078105, 'title': 'JackJones杰克琼斯秋冬男修身深色休闲潮牛仔九分长裤E|217332513', 'img': '//img.alicdn.com/bao/uploaded/i2/305358018/O1CN01296I84bmFoLnR1O-305358018.jpg', 'sold': '111', 'quantity': 0, 'totalSoldQuantity': 3600, 'url': '//detail.m.tmall.com/item.htm?id=551481078105', 'price': '399.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 572740078291, 'title': 'JackJones杰克琼斯男秋弹力修身直筒磨毛内里青年潮流牛仔裤长裤', 'img': '//img.alicdn.com/bao/uploaded/i1/305358018/O1CN01303XyR296I86E5wdI-305358018.jpg', 'sold': '2024', 'quantity': 0, 'totalSoldQuantity': 6061, 'url': '//detail.m.tmall.com/item.htm?id=572740078291', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 562539671129, 'title': 'JackJones杰克琼斯男秋季新品时尚宽松大码弹力直筒牛仔裤长裤子', 'img': '//img.alicdn.com/bao/uploaded/i3/305358018/O1CN01296I86bKkxDfZDd_!!0-item_pic.jpg', 'sold': '1931', 'quantity': 0, 'totalSoldQuantity': 32001, 'url': '//detail.m.tmall.com/item.htm?id=562539671129', 'price': '399.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 566211228523, 'title': 'JackJones杰克琼斯男士秋冬新款纯色弹力收口青年休闲运动裤卫裤', 'img': '//img.alicdn.com/bao/uploaded/i1/305358018/O1CN01vHD8O0296I874ySrK_!!0-item_pic.jpg', 'sold': '1368', 'quantity': 0, 'totalSoldQuantity': 15369, 'url': '//detail.m.tmall.com/item.htm?id=566211228523', 'price': '399.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 577358311944, 'title': '【邓伦同款】JackJones杰克琼斯冬男百搭简约格纹围巾E|218388504', 'img': '//img.alicdn.com/bao/uploaded/i2/305358018/O1CN01VFEgHK296I85GHgor-305358018.jpg', 'sold': '578', 'quantity': 0, 'totalSoldQuantity': 870, 'url': '//detail.m.tmall.com/item.htm?id=577358311944', 'price': '199.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 562312691909, 'title': 'JackJones杰克琼斯秋冬男士纯羊毛圆领拼色针织衫毛衣|218125505', 'img': '//img.alicdn.com/bao/uploaded/i3/305358018/O1CN01e81kr6296I87YYVsH-305358018.jpg', 'sold': '897', 'quantity': 0, 'totalSoldQuantity': 2076, 'url': '//detail.m.tmall.com/item.htm?id=562312691909', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 573924333507, 'title': 'JackJones杰克琼斯秋冬男羊毛衫商务条纹休闲圆领针织衫毛衣青年', 'img': '//img.alicdn.com/bao/uploaded/i1/305358018/O1CN01qlN6Xy296I7zmFXGq-305358018.jpg', 'sold': '970', 'quantity': 0, 'totalSoldQuantity': 1900, 'url': '//detail.m.tmall.com/item.htm?id=573924333507', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 561740896217, 'title': 'JackJones杰克琼斯秋冬男装棒球领PU皮衣夹克外套E|218121509', 'img': '//img.alicdn.com/bao/uploaded/i4/305358018/O1CN01XnHNTZ296I872HKAI_!!0-item_pic.jpg', 'sold': '976', 'quantity': 0, 'totalSoldQuantity': 3560, 'url': '//detail.m.tmall.com/item.htm?id=561740896217', 'price': '699.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 562463586739, 'title': 'JackJones杰克琼斯男秋冬秋纯棉纯色打底衫潮流百搭短袖T恤半袖', 'img': '//img.alicdn.com/bao/uploaded/i2/305358018/O1CN01s3kuVk296I86WijUy-305358018.jpg', 'sold': '1161', 'quantity': 0, 'totalSoldQuantity': 71917, 'url': '//detail.m.tmall.com/item.htm?id=562463586739', 'price': '99.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 570429147459, 'title': 'JackJones杰克琼斯秋冬男装舒适棉弹侧条纹休闲长裤子C|218114501', 'img': '//img.alicdn.com/bao/uploaded/i3/305358018/O1CN018zZ5BC296I8AzAh5w_!!0-item_pic.jpg', 'sold': '794', 'quantity': 0, 'totalSoldQuantity': 2089, 'url': '//detail.m.tmall.com/item.htm?id=570429147459', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 575277952566, 'title': 'JackJones杰克琼斯秋季男款立体字母印花插肩袖套头圆领卫衣纯色', 'img': '//img.alicdn.com/bao/uploaded/i4/305358018/O1CN01296I872NNS0nHtJ_!!0-item_pic.jpg', 'sold': '836', 'quantity': 0, 'totalSoldQuantity': 1989, 'url': '//detail.m.tmall.com/item.htm?id=575277952566', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 561962692090, 'title': 'JackJones杰克琼斯秋冬男修身小脚加厚潮深色牛仔长裤J|218132508', 'img': '//img.alicdn.com/bao/uploaded/i3/305358018/O1CN01byGwsm296I86DeDbM-305358018.jpg', 'sold': '669', 'quantity': 0, 'totalSoldQuantity': 1671, 'url': '//detail.m.tmall.com/item.htm?id=561962692090', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 564135312774, 'title': 'JackJones杰克琼斯秋冬男士潮流深色修身小脚牛仔长裤J|218132503', 'img': '//img.alicdn.com/bao/uploaded/i4/305358018/O1CN010wpUQR296I84293lU-305358018.jpg', 'sold': '697', 'quantity': 0, 'totalSoldQuantity': 1689, 'url': '//detail.m.tmall.com/item.htm?id=564135312774', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 572841015192, 'title': 'JackJones杰克琼斯男士秋冬潮流休闲运动连帽加绒厚卫衣开衫外套', 'img': '//img.alicdn.com/bao/uploaded/i2/305358018/O1CN01296I84cYJziNeLO-305358018.jpg', 'sold': '776', 'quantity': 0, 'totalSoldQuantity': 2374, 'url': '//detail.m.tmall.com/item.htm?id=572841015192', 'price': '399.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 563055414675, 'title': 'JackJones杰克琼斯男装秋冬PU人造皮革机车夹克外套E|218121514', 'img': '//img.alicdn.com/bao/uploaded/i4/305358018/O1CN01OZS81w296I87YZehk-305358018.jpg', 'sold': '525', 'quantity': 0, 'totalSoldQuantity': 1722, 'url': '//detail.m.tmall.com/item.htm?id=563055414675', 'price': '699.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 562760549759, 'title': 'JackJones杰克琼斯男秋冬新品弹力轻薄浅色刮破修身小脚牛仔长裤', 'img': '//img.alicdn.com/bao/uploaded/i1/305358018/O1CN01xnUl8e296I8ARBCWe_!!0-item_pic.jpg', 'sold': '658', 'quantity': 0, 'totalSoldQuantity': 15352, 'url': '//detail.m.tmall.com/item.htm?id=562760549759', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 562579957036, 'title': 'JackJones杰克琼斯男中长款太空棉秋冬季连帽风衣外套E|218121513', 'img': '//img.alicdn.com/bao/uploaded/i2/305358018/O1CN01s7HL8y296I84c3qPP-305358018.jpg', 'sold': '404', 'quantity': 0, 'totalSoldQuantity': 1276, 'url': '//detail.m.tmall.com/item.htm?id=562579957036', 'price': '799.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 577881255431, 'title': 'JackJones杰克琼斯冬男纯色休闲含羊毛保暖针织衫毛衣|218424507', 'img': '//img.alicdn.com/bao/uploaded/i1/305358018/O1CN01EslqQj296I86e3R07-305358018.jpg', 'sold': '389', 'quantity': 0, 'totalSoldQuantity': 605, 'url': '//detail.m.tmall.com/item.htm?id=577881255431', 'price': '399.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 562532623278, 'title': 'MLMR秋季潮男装男士宽松直筒棉弹纯色水洗休闲长裤子M|218114506', 'img': '//img.alicdn.com/bao/uploaded/i4/305358018/O1CN011AhDp5296I86oV4fc-305358018.jpg', 'sold': '633', 'quantity': 0, 'totalSoldQuantity': 6725, 'url': '//detail.m.tmall.com/item.htm?id=562532623278', 'price': '399.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 558958121571, 'title': 'JackJones杰克琼斯白鸭绒连帽轻薄男秋季羽绒棉服外套C|217312512', 'img': '//img.alicdn.com/bao/uploaded/i3/305358018/O1CN01296I85wM8f1eQHR-305358018.jpg', 'sold': '386', 'quantity': 0, 'totalSoldQuantity': 4423, 'url': '//detail.m.tmall.com/item.htm?id=558958121571', 'price': '799.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 573921485702, 'title': 'JackJones杰克琼斯秋季男款新款个性印花休闲圆领套头卫衣黑色潮', 'img': '//img.alicdn.com/bao/uploaded/i1/305358018/O1CN010YvIvC296I86DFy6M_!!0-item_pic.jpg', 'sold': '610', 'quantity': 0, 'totalSoldQuantity': 1350, 'url': '//detail.m.tmall.com/item.htm?id=573921485702', 'price': '499.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 563803033324, 'title': 'JackJones杰克琼斯男秋冬新品纯色修身韩版商务易烫翻领长袖衬衫', 'img': '//img.alicdn.com/bao/uploaded/i1/305358018/O1CN01296I86Wq7Jyde9W-305358018.jpg', 'sold': '644', 'quantity': 0, 'totalSoldQuantity': 9938, 'url': '//detail.m.tmall.com/item.htm?id=563803033324', 'price': '399.00', 'store_name': 'jackjones', 'page': '1'}, {'item_id': 562240782552, 'title': 'MLMR男士秋冬休闲法兰绒磨毛纯棉宽松格纹长袖衬衫衣M|218105506', 'img': '//img.alicdn.com/bao/uploaded/i4/305358018/O1CN019ce3eN296I86WgJmP-305358018.jpg', 'sold': '526', 'quantity': 0, 'totalSoldQuantity': 5530, 'url': '//detail.m.tmall.com/item.htm?id=562240782552', 'price': '399.00', 'store_name': 'jackjones', 'page': '2'}, {'item_id': 564442596872, 'title': 'JackJones杰克琼斯男装秋冬修身小脚潮弹力牛仔长裤子J|218132531', 'img': '//img.alicdn.com/bao/uploaded/i2/305358018/O1CN01PaZTGa296I86Pj5El-305358018.jpg', 'sold': '419', 'quantity': 0, 'totalSoldQuantity': 1810, 'url': '//detail.m.tmall.com/item.htm?id=564442596872', 'price': '499.00', 'store_name': 'jackjones', 'page': '2'}, {'item_id': 564496335236, 'title': 'JackJones杰克琼斯男士秋冬弹力太空棉休闲运动长卫裤E|218114554', 'img': '//img.alicdn.com/bao/uploaded/i2/305358018/O1CN01296I842CcCymGyq-305358018.jpg', 'sold': '421', 'quantity': 0, 'totalSoldQuantity': 1476, 'url': '//detail.m.tmall.com/item.htm?id=564496335236', 'price': '499.00', 'store_name': 'jackjones', 'page': '2'}, {'item_id': 563756926565, 'title': 'JackJones杰克琼斯男士秋冬休闲纯棉刺绣运动针织卫衣C|218133512', 'img': '//img.alicdn.com/bao/uploaded/i4/305358018/O1CN01296I7zlo92OEgm0-305358018.jpg', 'sold': '367', 'quantity': 0, 'totalSoldQuantity': 1934, 'url': '//detail.m.tmall.com/item.htm?id=563756926565', 'price': '399.00', 'store_name': 'jackjones', 'page': '2'}, {'item_id': 576509103465, 'title': '[邓伦同款]\u001b[0m\n\u001b[1;37m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            ^\u001b[0m\n\u001b[1;31mSyntaxError\u001b[0m\u001b[1;31m:\u001b[0m EOL while scanning string literal\n"
     ]
    }
   ],
   "source": [
    "all_brand = []\n",
    "for one_brand in lst_brand:\n",
    "    print(one_brand)\n",
    "    file1 = open(one_brand, 'r', encoding='utf-8')\n",
    "    file = file1.read()\n",
    "    test = re.compile(\"'titleUnderIconList'(.*?)'store_name'\")\n",
    "    new_file = test.sub(\"'store_name'\", file)\n",
    "    last_file = new_file.split(']')[1:-1]\n",
    "    all_page = []\n",
    "    for one_page in last_file:\n",
    "        pages = eval(one_page + ']')\n",
    "        df = pd.DataFrame(pages)\n",
    "        all_page.append(df)\n",
    "    brand = pd.concat(all_page, sort=True)\n",
    "    brand.to_excel('d:\\\\test\\\\brand\\\\{}.xlsx'.format(one_brand.split('\\\\')[-1]))\n",
    "    all_brand.append(brand)\n",
    "    file1.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>img</th>\n",
       "      <th>item_id</th>\n",
       "      <th>page</th>\n",
       "      <th>price</th>\n",
       "      <th>quantity</th>\n",
       "      <th>sold</th>\n",
       "      <th>store_name</th>\n",
       "      <th>title</th>\n",
       "      <th>totalSoldQuantity</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>556905499087</td>\n",
       "      <td>1</td>\n",
       "      <td>679.00</td>\n",
       "      <td>0</td>\n",
       "      <td>838</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男装男士外套冬季新款轻薄羽绒服男轻便薄款外套男短款</td>\n",
       "      <td>30913</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=556905499087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>574998833929</td>\n",
       "      <td>1</td>\n",
       "      <td>389.00</td>\n",
       "      <td>0</td>\n",
       "      <td>788</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男装秋季纯色毛衣男宽松圆领针织衫男长袖套头衫男生青年线衣</td>\n",
       "      <td>2052</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=574998833929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>573079737250</td>\n",
       "      <td>1</td>\n",
       "      <td>269.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1056</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季男装2018新款连帽卫衣男潮假两件套头潮流嘻哈男生外套秋</td>\n",
       "      <td>5969</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=573079737250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>555337765523</td>\n",
       "      <td>1</td>\n",
       "      <td>289.00</td>\n",
       "      <td>0</td>\n",
       "      <td>3282</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季男士牛仔裤男潮弹力小脚裤修身潮流牛仔裤子学生休闲长裤</td>\n",
       "      <td>58030</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=555337765523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>554908919545</td>\n",
       "      <td>1</td>\n",
       "      <td>279.00</td>\n",
       "      <td>0</td>\n",
       "      <td>2695</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男士弹力休闲裤男修身潮流休闲百搭秋冬裤子男潮秋季小脚男裤</td>\n",
       "      <td>47665</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=554908919545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>572188104468</td>\n",
       "      <td>1</td>\n",
       "      <td>299.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1301</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季工装裤男潮牌束脚裤 欧美嘻哈街头九分休闲裤子男运动纯棉</td>\n",
       "      <td>7093</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572188104468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>574480863419</td>\n",
       "      <td>1</td>\n",
       "      <td>439.00</td>\n",
       "      <td>0</td>\n",
       "      <td>809</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季英伦连帽风衣男短款时尚外套男撞色潮牌冲锋衣新款2018</td>\n",
       "      <td>3693</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=574480863419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>554820553199</td>\n",
       "      <td>1</td>\n",
       "      <td>239.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1937</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男士衬衣白衬衫男长袖纯棉休闲牛津纺修身白色上衣潮</td>\n",
       "      <td>36348</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=554820553199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>572319301147</td>\n",
       "      <td>1</td>\n",
       "      <td>329.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1651</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21新款2018秋季男生牛仔裤男修身小脚潮流弹力秋冬款男士裤子潮</td>\n",
       "      <td>8045</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572319301147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>572711994246</td>\n",
       "      <td>1</td>\n",
       "      <td>329.00</td>\n",
       "      <td>0</td>\n",
       "      <td>735</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21九分裤男修身2018新款秋季低腰弹力水洗学生简约男士牛仔裤潮</td>\n",
       "      <td>3368</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572711994246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>575214883533</td>\n",
       "      <td>1</td>\n",
       "      <td>319.00</td>\n",
       "      <td>0</td>\n",
       "      <td>885</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季新款2018外套男装黄色连帽卫衣男长袖学生潮牌秋装上衣</td>\n",
       "      <td>3165</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=575214883533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>575286615334</td>\n",
       "      <td>1</td>\n",
       "      <td>319.00</td>\n",
       "      <td>0</td>\n",
       "      <td>523</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21宽松横条纹毛衣男秋季新款男装 撞色男士毛衫圆领打底衫男线衣</td>\n",
       "      <td>1041</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=575286615334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>572320961073</td>\n",
       "      <td>1</td>\n",
       "      <td>249.00</td>\n",
       "      <td>0</td>\n",
       "      <td>986</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21潮流2018新款秋季男装圆领卫衣男潮长袖学生潮牌男装套头外套</td>\n",
       "      <td>4310</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572320961073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>576015193973</td>\n",
       "      <td>1</td>\n",
       "      <td>949.00</td>\n",
       "      <td>0</td>\n",
       "      <td>339</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21冬季2018新款男款中厚外套男保暖连帽短款加厚羽绒服男潮牌</td>\n",
       "      <td>634</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=576015193973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>575072825403</td>\n",
       "      <td>1</td>\n",
       "      <td>319.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1325</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季撞色刺绣毛衣男宽松圆领街头线衣假两件男冬季男装针织衫</td>\n",
       "      <td>2446</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=575072825403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>572809503192</td>\n",
       "      <td>1</td>\n",
       "      <td>329.00</td>\n",
       "      <td>0</td>\n",
       "      <td>403</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21九分裤男束脚 2018秋季新款学生弹力潮流青年黑色男士休闲裤</td>\n",
       "      <td>1222</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572809503192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>577691112570</td>\n",
       "      <td>1</td>\n",
       "      <td>929.00</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋冬新款男装羽绒服 潮流男百搭合体可拆帽长袖中长厚羽绒外套</td>\n",
       "      <td>16</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=577691112570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>577204742354</td>\n",
       "      <td>1</td>\n",
       "      <td>929.00</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋冬新款男羽绒服短款时尚休闲加厚保暖男士外套连帽羽绒男</td>\n",
       "      <td>10</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=577204742354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>577191648860</td>\n",
       "      <td>1</td>\n",
       "      <td>869.00</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋冬羽绒服男2018新款短款时尚保暖帅气连帽男装外套潮学生</td>\n",
       "      <td>93</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=577191648860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>574999729118</td>\n",
       "      <td>1</td>\n",
       "      <td>319.00</td>\n",
       "      <td>0</td>\n",
       "      <td>719</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季新款2018男装 弹力牛仔裤修身简约百搭男裤子挂件装饰潮裤</td>\n",
       "      <td>2448</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=574999729118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>576921364162</td>\n",
       "      <td>1</td>\n",
       "      <td>569.00</td>\n",
       "      <td>0</td>\n",
       "      <td>208</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋冬季新款潮牌棉衣男 撞色棉服男保暖潮流面包服男士外套防寒</td>\n",
       "      <td>336</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=576921364162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>574120912975</td>\n",
       "      <td>1</td>\n",
       "      <td>219.00</td>\n",
       "      <td>0</td>\n",
       "      <td>911</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季圆领长袖T恤男秋衣内搭 印花潮流套头打底衫新款2018男装</td>\n",
       "      <td>2218</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=574120912975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>577357617691</td>\n",
       "      <td>1</td>\n",
       "      <td>349.00</td>\n",
       "      <td>0</td>\n",
       "      <td>170</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋冬新款加绒男牛仔裤弹力修身小脚长裤 时尚潮流撞色刺绣男裤</td>\n",
       "      <td>288</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=577357617691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/TB...</td>\n",
       "      <td>575754052967</td>\n",
       "      <td>1</td>\n",
       "      <td>319.00</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季2018新品男装 时尚潮男牛仔长裤弹力修身低腰做旧窄脚裤子</td>\n",
       "      <td>267</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=575754052967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>556905499087</td>\n",
       "      <td>1</td>\n",
       "      <td>679.00</td>\n",
       "      <td>0</td>\n",
       "      <td>838</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男装男士外套冬季新款轻薄羽绒服男轻便薄款外套男短款</td>\n",
       "      <td>30913</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=556905499087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>574998833929</td>\n",
       "      <td>1</td>\n",
       "      <td>389.00</td>\n",
       "      <td>0</td>\n",
       "      <td>788</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男装秋季纯色毛衣男宽松圆领针织衫男长袖套头衫男生青年线衣</td>\n",
       "      <td>2052</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=574998833929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>573079737250</td>\n",
       "      <td>1</td>\n",
       "      <td>269.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1056</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季男装2018新款连帽卫衣男潮假两件套头潮流嘻哈男生外套秋</td>\n",
       "      <td>5969</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=573079737250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>555337765523</td>\n",
       "      <td>1</td>\n",
       "      <td>289.00</td>\n",
       "      <td>0</td>\n",
       "      <td>3282</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季男士牛仔裤男潮弹力小脚裤修身潮流牛仔裤子学生休闲长裤</td>\n",
       "      <td>58030</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=555337765523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>554908919545</td>\n",
       "      <td>1</td>\n",
       "      <td>279.00</td>\n",
       "      <td>0</td>\n",
       "      <td>2695</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男士弹力休闲裤男修身潮流休闲百搭秋冬裤子男潮秋季小脚男裤</td>\n",
       "      <td>47665</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=554908919545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>572188104468</td>\n",
       "      <td>1</td>\n",
       "      <td>299.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1301</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21秋季工装裤男潮牌束脚裤 欧美嘻哈街头九分休闲裤子男运动纯棉</td>\n",
       "      <td>7093</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572188104468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1434</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>567348321327</td>\n",
       "      <td>60</td>\n",
       "      <td>269.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏季新款男装水洗牛仔短裤 男士潮流破洞男青年纯棉舒适夏裤子</td>\n",
       "      <td>1356</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567348321327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1435</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>567963127833</td>\n",
       "      <td>60</td>\n",
       "      <td>229.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏装2018新款衬衫男纯棉修身圆领青少年休闲男士短袖牛仔衬衣</td>\n",
       "      <td>1142</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567963127833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1436</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>566413068582</td>\n",
       "      <td>60</td>\n",
       "      <td>189.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏季新款男装短袖polo衫 个性撞色袖口短袖男青年校园短polo衫</td>\n",
       "      <td>2350</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566413068582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1437</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>565575446932</td>\n",
       "      <td>60</td>\n",
       "      <td>239.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏装新款男装短袖衬衫 立领纯色亚麻男士短袖衫文艺小清新上衣</td>\n",
       "      <td>796</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=565575446932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1438</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>565992072250</td>\n",
       "      <td>60</td>\n",
       "      <td>219.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏季男新品短袖衬衫 男装翻领格子刺绣字母纯棉修身短袖上衣</td>\n",
       "      <td>666</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=565992072250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>566615380509</td>\n",
       "      <td>60</td>\n",
       "      <td>229.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21女装浅色牛仔短裤 夏季2018新款潮流水洗破洞高腰牛仔短裤女裤</td>\n",
       "      <td>632</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566615380509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1440</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>566615392793</td>\n",
       "      <td>61</td>\n",
       "      <td>229.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏季新款2018女装牛仔短裤 女夏休闲纯棉毛边学生个性女生裤子</td>\n",
       "      <td>708</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566615392793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1441</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>567588370827</td>\n",
       "      <td>61</td>\n",
       "      <td>209.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21短袖女2018新款夏季休闲少女体恤圆领条纹学生假两件t恤上衣</td>\n",
       "      <td>99</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567588370827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1442</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>566287302123</td>\n",
       "      <td>61</td>\n",
       "      <td>249.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏装新品女装连衣裙 一字领条纹女生小清新裙子舒适纯棉女裙装</td>\n",
       "      <td>45</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566287302123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1443</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>566375603378</td>\n",
       "      <td>61</td>\n",
       "      <td>189.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21高腰宽松短裤女 2018夏装新款纯色舒适青春活力休闲裤夏装女</td>\n",
       "      <td>85</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566375603378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1444</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>566615604397</td>\n",
       "      <td>61</td>\n",
       "      <td>199.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21女装高腰短裤女夏2018新款学生简约休闲开叉女生弹力宽松裤子</td>\n",
       "      <td>435</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566615604397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1445</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>567930565459</td>\n",
       "      <td>61</td>\n",
       "      <td>249.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21衬衣女2018新款休闲纯色简约翻领宽松弹力短袖蝴蝶结女士衬衫</td>\n",
       "      <td>373</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567930565459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1446</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>565991748921</td>\n",
       "      <td>61</td>\n",
       "      <td>189.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏季新款短裤 男装针织青年修身绑带个性贴章运动短裤男休闲裤</td>\n",
       "      <td>422</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=565991748921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1447</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>567788913888</td>\n",
       "      <td>61</td>\n",
       "      <td>219.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21新款短裤男针织低腰修身个性字母绣花男士黑白拼色弹力五分裤</td>\n",
       "      <td>2082</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567788913888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1448</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>563661606606</td>\n",
       "      <td>61</td>\n",
       "      <td>119.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21春装女装短袖T恤 休闲舒适纯色修身圆领绑带女生甜美短袖衫</td>\n",
       "      <td>81</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=563661606606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1449</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>567729396826</td>\n",
       "      <td>61</td>\n",
       "      <td>229.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男装衬衫2018夏季新款翻领短袖衬衫 舒适休闲字母印花短袖衬衣</td>\n",
       "      <td>257</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567729396826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1450</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>568528438582</td>\n",
       "      <td>61</td>\n",
       "      <td>189.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男装polo衫2018夏季新款 男针织休闲舒适黑白撞色翻领短袖上衣</td>\n",
       "      <td>89</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=568528438582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1451</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>559759591152</td>\n",
       "      <td>61</td>\n",
       "      <td>419.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21冬季2018棉衣女装 青春纯色加厚保暖宽松女生棒球服外套</td>\n",
       "      <td>260</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=559759591152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1452</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>563727269410</td>\n",
       "      <td>61</td>\n",
       "      <td>179.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21春季新款外穿中腰短裤女 2018时尚休闲学生撞色百搭女装裤子</td>\n",
       "      <td>209</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=563727269410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1453</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>566287182140</td>\n",
       "      <td>61</td>\n",
       "      <td>229.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21新款宽松牛仔短裤女纯棉女生休闲学生潮流浅色高腰女装裤子</td>\n",
       "      <td>267</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566287182140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1454</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>567588310902</td>\n",
       "      <td>61</td>\n",
       "      <td>219.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏季新款翻领女短袖衬衫 橄榄绿后背镂空衬衫个性绑带衬衫女衣</td>\n",
       "      <td>95</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567588310902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1455</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>567588442716</td>\n",
       "      <td>61</td>\n",
       "      <td>199.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21女短裤2018新款弹力休闲宽松学生拼色潮流女生甜美可爱裤子</td>\n",
       "      <td>498</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567588442716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1456</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>568600158504</td>\n",
       "      <td>61</td>\n",
       "      <td>199.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21女装2018夏季新款宽松连帽背心 女青年针织字母印花卫衣无袖衣</td>\n",
       "      <td>62</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=568600158504</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1457</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>565216318980</td>\n",
       "      <td>61</td>\n",
       "      <td>219.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏装新款男装牛仔短裤 低腰休闲纯棉舒适印花男青年水洗裤子</td>\n",
       "      <td>1249</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=565216318980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1458</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>566107785745</td>\n",
       "      <td>61</td>\n",
       "      <td>249.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏装新款牛仔短裤 男装流苏低腰纯棉潮流直筒无弹散边男青年裤</td>\n",
       "      <td>288</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566107785745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>566617566640</td>\n",
       "      <td>61</td>\n",
       "      <td>269.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏季新款男士牛仔裤 浅蓝水洗个性潮流纯棉透气破洞男夏短裤潮</td>\n",
       "      <td>1726</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566617566640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1460</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>567434010743</td>\n",
       "      <td>61</td>\n",
       "      <td>279.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏季新款牛仔短裤男纯棉迷彩卷边裤脚个性潮流破洞天蓝色裤子</td>\n",
       "      <td>459</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567434010743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1461</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>567668756361</td>\n",
       "      <td>61</td>\n",
       "      <td>279.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男装2018夏季新款休闲牛仔短裤 男青年潮流绑带深蓝弹力短裤夏</td>\n",
       "      <td>745</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=567668756361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1462</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>564816961472</td>\n",
       "      <td>61</td>\n",
       "      <td>219.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21男装修身翻领短袖衬衫男 夏季新款2018青年字母印花男士衬衣</td>\n",
       "      <td>789</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=564816961472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1463</th>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>565217274644</td>\n",
       "      <td>61</td>\n",
       "      <td>249.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>A21夏季2018新款短袖衬衫男纯棉男士翻领青年字母印花牛仔衬衣</td>\n",
       "      <td>448</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=565217274644</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>45384 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    img       item_id page  \\\n",
       "0     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  556905499087    1   \n",
       "1     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  574998833929    1   \n",
       "2     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  573079737250    1   \n",
       "3     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  555337765523    1   \n",
       "4     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  554908919545    1   \n",
       "5     //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  572188104468    1   \n",
       "6     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  574480863419    1   \n",
       "7     //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  554820553199    1   \n",
       "8     //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  572319301147    1   \n",
       "9     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  572711994246    1   \n",
       "10    //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  575214883533    1   \n",
       "11    //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  575286615334    1   \n",
       "12    //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  572320961073    1   \n",
       "13    //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  576015193973    1   \n",
       "14    //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  575072825403    1   \n",
       "15    //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  572809503192    1   \n",
       "16    //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  577691112570    1   \n",
       "17    //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  577204742354    1   \n",
       "18    //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  577191648860    1   \n",
       "19    //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  574999729118    1   \n",
       "20    //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  576921364162    1   \n",
       "21    //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  574120912975    1   \n",
       "22    //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  577357617691    1   \n",
       "23    //img.alicdn.com/bao/uploaded/i1/1601145275/TB...  575754052967    1   \n",
       "0     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  556905499087    1   \n",
       "1     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  574998833929    1   \n",
       "2     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  573079737250    1   \n",
       "3     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  555337765523    1   \n",
       "4     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  554908919545    1   \n",
       "5     //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  572188104468    1   \n",
       "...                                                 ...           ...  ...   \n",
       "1434  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  567348321327   60   \n",
       "1435  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  567963127833   60   \n",
       "1436  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  566413068582   60   \n",
       "1437  //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  565575446932   60   \n",
       "1438  //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  565992072250   60   \n",
       "1439  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  566615380509   60   \n",
       "1440  //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  566615392793   61   \n",
       "1441  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  567588370827   61   \n",
       "1442  //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  566287302123   61   \n",
       "1443  //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  566375603378   61   \n",
       "1444  //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  566615604397   61   \n",
       "1445  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  567930565459   61   \n",
       "1446  //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  565991748921   61   \n",
       "1447  //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  567788913888   61   \n",
       "1448  //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  563661606606   61   \n",
       "1449  //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  567729396826   61   \n",
       "1450  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  568528438582   61   \n",
       "1451  //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  559759591152   61   \n",
       "1452  //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  563727269410   61   \n",
       "1453  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  566287182140   61   \n",
       "1454  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  567588310902   61   \n",
       "1455  //img.alicdn.com/bao/uploaded/i1/1601145275/O1...  567588442716   61   \n",
       "1456  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  568600158504   61   \n",
       "1457  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  565216318980   61   \n",
       "1458  //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  566107785745   61   \n",
       "1459  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  566617566640   61   \n",
       "1460  //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  567434010743   61   \n",
       "1461  //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  567668756361   61   \n",
       "1462  //img.alicdn.com/bao/uploaded/i2/1601145275/O1...  564816961472   61   \n",
       "1463  //img.alicdn.com/bao/uploaded/i3/1601145275/O1...  565217274644   61   \n",
       "\n",
       "       price  quantity  sold store_name                                 title  \\\n",
       "0     679.00         0   838      a21fs          A21男装男士外套冬季新款轻薄羽绒服男轻便薄款外套男短款   \n",
       "1     389.00         0   788      a21fs       A21男装秋季纯色毛衣男宽松圆领针织衫男长袖套头衫男生青年线衣   \n",
       "2     269.00         0  1056      a21fs     A21秋季男装2018新款连帽卫衣男潮假两件套头潮流嘻哈男生外套秋   \n",
       "3     289.00         0  3282      a21fs       A21秋季男士牛仔裤男潮弹力小脚裤修身潮流牛仔裤子学生休闲长裤   \n",
       "4     279.00         0  2695      a21fs       A21男士弹力休闲裤男修身潮流休闲百搭秋冬裤子男潮秋季小脚男裤   \n",
       "5     299.00         0  1301      a21fs      A21秋季工装裤男潮牌束脚裤 欧美嘻哈街头九分休闲裤子男运动纯棉   \n",
       "6     439.00         0   809      a21fs      A21秋季英伦连帽风衣男短款时尚外套男撞色潮牌冲锋衣新款2018   \n",
       "7     239.00         0  1937      a21fs           A21男士衬衣白衬衫男长袖纯棉休闲牛津纺修身白色上衣潮   \n",
       "8     329.00         0  1651      a21fs     A21新款2018秋季男生牛仔裤男修身小脚潮流弹力秋冬款男士裤子潮   \n",
       "9     329.00         0   735      a21fs     A21九分裤男修身2018新款秋季低腰弹力水洗学生简约男士牛仔裤潮   \n",
       "10    319.00         0   885      a21fs      A21秋季新款2018外套男装黄色连帽卫衣男长袖学生潮牌秋装上衣   \n",
       "11    319.00         0   523      a21fs      A21宽松横条纹毛衣男秋季新款男装 撞色男士毛衫圆领打底衫男线衣   \n",
       "12    249.00         0   986      a21fs     A21潮流2018新款秋季男装圆领卫衣男潮长袖学生潮牌男装套头外套   \n",
       "13    949.00         0   339      a21fs      A21冬季2018新款男款中厚外套男保暖连帽短款加厚羽绒服男潮牌   \n",
       "14    319.00         0  1325      a21fs       A21秋季撞色刺绣毛衣男宽松圆领街头线衣假两件男冬季男装针织衫   \n",
       "15    329.00         0   403      a21fs     A21九分裤男束脚 2018秋季新款学生弹力潮流青年黑色男士休闲裤   \n",
       "16    929.00         0    16      a21fs      A21秋冬新款男装羽绒服 潮流男百搭合体可拆帽长袖中长厚羽绒外套   \n",
       "17    929.00         0    11      a21fs        A21秋冬新款男羽绒服短款时尚休闲加厚保暖男士外套连帽羽绒男   \n",
       "18    869.00         0    73      a21fs      A21秋冬羽绒服男2018新款短款时尚保暖帅气连帽男装外套潮学生   \n",
       "19    319.00         0   719      a21fs    A21秋季新款2018男装 弹力牛仔裤修身简约百搭男裤子挂件装饰潮裤   \n",
       "20    569.00         0   208      a21fs      A21秋冬季新款潮牌棉衣男 撞色棉服男保暖潮流面包服男士外套防寒   \n",
       "21    219.00         0   911      a21fs    A21秋季圆领长袖T恤男秋衣内搭 印花潮流套头打底衫新款2018男装   \n",
       "22    349.00         0   170      a21fs      A21秋冬新款加绒男牛仔裤弹力修身小脚长裤 时尚潮流撞色刺绣男裤   \n",
       "23    319.00         0   119      a21fs    A21秋季2018新品男装 时尚潮男牛仔长裤弹力修身低腰做旧窄脚裤子   \n",
       "0     679.00         0   838      a21fs          A21男装男士外套冬季新款轻薄羽绒服男轻便薄款外套男短款   \n",
       "1     389.00         0   788      a21fs       A21男装秋季纯色毛衣男宽松圆领针织衫男长袖套头衫男生青年线衣   \n",
       "2     269.00         0  1056      a21fs     A21秋季男装2018新款连帽卫衣男潮假两件套头潮流嘻哈男生外套秋   \n",
       "3     289.00         0  3282      a21fs       A21秋季男士牛仔裤男潮弹力小脚裤修身潮流牛仔裤子学生休闲长裤   \n",
       "4     279.00         0  2695      a21fs       A21男士弹力休闲裤男修身潮流休闲百搭秋冬裤子男潮秋季小脚男裤   \n",
       "5     299.00         0  1301      a21fs      A21秋季工装裤男潮牌束脚裤 欧美嘻哈街头九分休闲裤子男运动纯棉   \n",
       "...      ...       ...   ...        ...                                   ...   \n",
       "1434  269.00         0     0      a21fs      A21夏季新款男装水洗牛仔短裤 男士潮流破洞男青年纯棉舒适夏裤子   \n",
       "1435  229.00         0     0      a21fs     A21夏装2018新款衬衫男纯棉修身圆领青少年休闲男士短袖牛仔衬衣   \n",
       "1436  189.00         0     0      a21fs  A21夏季新款男装短袖polo衫 个性撞色袖口短袖男青年校园短polo衫   \n",
       "1437  239.00         0     0      a21fs      A21夏装新款男装短袖衬衫 立领纯色亚麻男士短袖衫文艺小清新上衣   \n",
       "1438  219.00         0     0      a21fs       A21夏季男新品短袖衬衫 男装翻领格子刺绣字母纯棉修身短袖上衣   \n",
       "1439  229.00         0     0      a21fs    A21女装浅色牛仔短裤 夏季2018新款潮流水洗破洞高腰牛仔短裤女裤   \n",
       "1440  229.00         0     0      a21fs    A21夏季新款2018女装牛仔短裤 女夏休闲纯棉毛边学生个性女生裤子   \n",
       "1441  209.00         0     0      a21fs     A21短袖女2018新款夏季休闲少女体恤圆领条纹学生假两件t恤上衣   \n",
       "1442  249.00         0     0      a21fs      A21夏装新品女装连衣裙 一字领条纹女生小清新裙子舒适纯棉女裙装   \n",
       "1443  189.00         0     0      a21fs     A21高腰宽松短裤女 2018夏装新款纯色舒适青春活力休闲裤夏装女   \n",
       "1444  199.00         0     0      a21fs     A21女装高腰短裤女夏2018新款学生简约休闲开叉女生弹力宽松裤子   \n",
       "1445  249.00         0     0      a21fs     A21衬衣女2018新款休闲纯色简约翻领宽松弹力短袖蝴蝶结女士衬衫   \n",
       "1446  189.00         0     0      a21fs      A21夏季新款短裤 男装针织青年修身绑带个性贴章运动短裤男休闲裤   \n",
       "1447  219.00         0     0      a21fs       A21新款短裤男针织低腰修身个性字母绣花男士黑白拼色弹力五分裤   \n",
       "1448  119.00         0     0      a21fs       A21春装女装短袖T恤 休闲舒适纯色修身圆领绑带女生甜美短袖衫   \n",
       "1449  229.00         0     0      a21fs    A21男装衬衫2018夏季新款翻领短袖衬衫 舒适休闲字母印花短袖衬衣   \n",
       "1450  189.00         0     0      a21fs  A21男装polo衫2018夏季新款 男针织休闲舒适黑白撞色翻领短袖上衣   \n",
       "1451  419.00         0     0      a21fs       A21冬季2018棉衣女装 青春纯色加厚保暖宽松女生棒球服外套   \n",
       "1452  179.00         0     0      a21fs     A21春季新款外穿中腰短裤女 2018时尚休闲学生撞色百搭女装裤子   \n",
       "1453  229.00         0     0      a21fs        A21新款宽松牛仔短裤女纯棉女生休闲学生潮流浅色高腰女装裤子   \n",
       "1454  219.00         0     0      a21fs      A21夏季新款翻领女短袖衬衫 橄榄绿后背镂空衬衫个性绑带衬衫女衣   \n",
       "1455  199.00         0     0      a21fs      A21女短裤2018新款弹力休闲宽松学生拼色潮流女生甜美可爱裤子   \n",
       "1456  199.00         0     0      a21fs    A21女装2018夏季新款宽松连帽背心 女青年针织字母印花卫衣无袖衣   \n",
       "1457  219.00         0     0      a21fs       A21夏装新款男装牛仔短裤 低腰休闲纯棉舒适印花男青年水洗裤子   \n",
       "1458  249.00         0     0      a21fs      A21夏装新款牛仔短裤 男装流苏低腰纯棉潮流直筒无弹散边男青年裤   \n",
       "1459  269.00         0     1      a21fs      A21夏季新款男士牛仔裤 浅蓝水洗个性潮流纯棉透气破洞男夏短裤潮   \n",
       "1460  279.00         0     0      a21fs       A21夏季新款牛仔短裤男纯棉迷彩卷边裤脚个性潮流破洞天蓝色裤子   \n",
       "1461  279.00         0     0      a21fs    A21男装2018夏季新款休闲牛仔短裤 男青年潮流绑带深蓝弹力短裤夏   \n",
       "1462  219.00         0     0      a21fs     A21男装修身翻领短袖衬衫男 夏季新款2018青年字母印花男士衬衣   \n",
       "1463  249.00         0     0      a21fs      A21夏季2018新款短袖衬衫男纯棉男士翻领青年字母印花牛仔衬衣   \n",
       "\n",
       "      totalSoldQuantity                                            url  \n",
       "0                 30913  //detail.m.tmall.com/item.htm?id=556905499087  \n",
       "1                  2052  //detail.m.tmall.com/item.htm?id=574998833929  \n",
       "2                  5969  //detail.m.tmall.com/item.htm?id=573079737250  \n",
       "3                 58030  //detail.m.tmall.com/item.htm?id=555337765523  \n",
       "4                 47665  //detail.m.tmall.com/item.htm?id=554908919545  \n",
       "5                  7093  //detail.m.tmall.com/item.htm?id=572188104468  \n",
       "6                  3693  //detail.m.tmall.com/item.htm?id=574480863419  \n",
       "7                 36348  //detail.m.tmall.com/item.htm?id=554820553199  \n",
       "8                  8045  //detail.m.tmall.com/item.htm?id=572319301147  \n",
       "9                  3368  //detail.m.tmall.com/item.htm?id=572711994246  \n",
       "10                 3165  //detail.m.tmall.com/item.htm?id=575214883533  \n",
       "11                 1041  //detail.m.tmall.com/item.htm?id=575286615334  \n",
       "12                 4310  //detail.m.tmall.com/item.htm?id=572320961073  \n",
       "13                  634  //detail.m.tmall.com/item.htm?id=576015193973  \n",
       "14                 2446  //detail.m.tmall.com/item.htm?id=575072825403  \n",
       "15                 1222  //detail.m.tmall.com/item.htm?id=572809503192  \n",
       "16                   16  //detail.m.tmall.com/item.htm?id=577691112570  \n",
       "17                   10  //detail.m.tmall.com/item.htm?id=577204742354  \n",
       "18                   93  //detail.m.tmall.com/item.htm?id=577191648860  \n",
       "19                 2448  //detail.m.tmall.com/item.htm?id=574999729118  \n",
       "20                  336  //detail.m.tmall.com/item.htm?id=576921364162  \n",
       "21                 2218  //detail.m.tmall.com/item.htm?id=574120912975  \n",
       "22                  288  //detail.m.tmall.com/item.htm?id=577357617691  \n",
       "23                  267  //detail.m.tmall.com/item.htm?id=575754052967  \n",
       "0                 30913  //detail.m.tmall.com/item.htm?id=556905499087  \n",
       "1                  2052  //detail.m.tmall.com/item.htm?id=574998833929  \n",
       "2                  5969  //detail.m.tmall.com/item.htm?id=573079737250  \n",
       "3                 58030  //detail.m.tmall.com/item.htm?id=555337765523  \n",
       "4                 47665  //detail.m.tmall.com/item.htm?id=554908919545  \n",
       "5                  7093  //detail.m.tmall.com/item.htm?id=572188104468  \n",
       "...                 ...                                            ...  \n",
       "1434               1356  //detail.m.tmall.com/item.htm?id=567348321327  \n",
       "1435               1142  //detail.m.tmall.com/item.htm?id=567963127833  \n",
       "1436               2350  //detail.m.tmall.com/item.htm?id=566413068582  \n",
       "1437                796  //detail.m.tmall.com/item.htm?id=565575446932  \n",
       "1438                666  //detail.m.tmall.com/item.htm?id=565992072250  \n",
       "1439                632  //detail.m.tmall.com/item.htm?id=566615380509  \n",
       "1440                708  //detail.m.tmall.com/item.htm?id=566615392793  \n",
       "1441                 99  //detail.m.tmall.com/item.htm?id=567588370827  \n",
       "1442                 45  //detail.m.tmall.com/item.htm?id=566287302123  \n",
       "1443                 85  //detail.m.tmall.com/item.htm?id=566375603378  \n",
       "1444                435  //detail.m.tmall.com/item.htm?id=566615604397  \n",
       "1445                373  //detail.m.tmall.com/item.htm?id=567930565459  \n",
       "1446                422  //detail.m.tmall.com/item.htm?id=565991748921  \n",
       "1447               2082  //detail.m.tmall.com/item.htm?id=567788913888  \n",
       "1448                 81  //detail.m.tmall.com/item.htm?id=563661606606  \n",
       "1449                257  //detail.m.tmall.com/item.htm?id=567729396826  \n",
       "1450                 89  //detail.m.tmall.com/item.htm?id=568528438582  \n",
       "1451                260  //detail.m.tmall.com/item.htm?id=559759591152  \n",
       "1452                209  //detail.m.tmall.com/item.htm?id=563727269410  \n",
       "1453                267  //detail.m.tmall.com/item.htm?id=566287182140  \n",
       "1454                 95  //detail.m.tmall.com/item.htm?id=567588310902  \n",
       "1455                498  //detail.m.tmall.com/item.htm?id=567588442716  \n",
       "1456                 62  //detail.m.tmall.com/item.htm?id=568600158504  \n",
       "1457               1249  //detail.m.tmall.com/item.htm?id=565216318980  \n",
       "1458                288  //detail.m.tmall.com/item.htm?id=566107785745  \n",
       "1459               1726  //detail.m.tmall.com/item.htm?id=566617566640  \n",
       "1460                459  //detail.m.tmall.com/item.htm?id=567434010743  \n",
       "1461                745  //detail.m.tmall.com/item.htm?id=567668756361  \n",
       "1462                789  //detail.m.tmall.com/item.htm?id=564816961472  \n",
       "1463                448  //detail.m.tmall.com/item.htm?id=565217274644  \n",
       "\n",
       "[45384 rows x 10 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
